create procedure [dbo].[BAEGetSuperProductAttributeValuesForProductView] @PID int,
     @PAID int as
SELECT DISTINCT av.Title, av.OrderSuperProductAttributeValueID
    FROM OrderSuperProductAttributeValue AS av INNER JOIN
        OrderSuperProductAttributeLookup AS al ON av.OrderSuperProductAttributeID = al.OrderSuperProductAttributeID INNER JOIN
        OrderSuperProductChildProduct AS cp ON al.OrderProductID = cp.OrderProductID INNER JOIN
        OrderSuperProductChildProductAttribute AS cpa ON av.OrderSuperProductAttributeValueID = cpa.OrderSuperProductAttributeValueID AND
        cp.OrderSuperProductChildProductID = cpa.OrderSuperProductChildProductID
        INNER JOIN Product_Inventory pinv ON pinv.PRODUCT_CODE COLLATE database_default = cp.ProductCode COLLATE database_default
    WHERE al.OrderProductID = @PID
    AND (pinv.QUANTITY_AVAILABLE > 0)
    AND av.OrderSuperProductAttributeID = @PAID

GO